Doctor of Philosophy in Computer Science and Information Systems Working Paper CSIS 2004-003 Efficiency Models for Data Warehouse Operations

We present efficiency models to evaluate data warehouse operations and analyze a preliminary data set using one of the models. The macro model represents the efficiency of operating a collection of data warehouses for both refresh processing and query production over a monthly horizon. The micro models represent the efficiency of daily operations an individual data warehouse for either refresh processing or query production. The variables in the models include traditional resource consumption (labor usage and computing budgets), system usage measures (usage time, users, and queries), data quality measures (timeliness and availability), and size measures (logical size, physical size, change data amounts, and data sources). We report on the evaluation of a preliminary data set for the refresh efficiency model using input-oriented Data Envelopment Analysis. We compare the efficiency of refresh processing in hypothetical data warehouses using constant returns, variable returns, and fuzzy DEA.